TRUNC[ATE] (number)

Purpose

This function trims number n to integer places behind the decimal point.

Syntax

trunc (number)::=

Usage Notes

  • If the second argument is not specified, trimming is conducted to a whole number.
  • If the second argument is negative, trimming is conducted to integer digits in front of the decimal point.

Example

SELECT TRUNC(123.456,2) TRUNC;